CREATE TABLE [dbo].[TimeBoard] (
    [ID]                      INT             IDENTITY (1, 1) NOT NULL,
    [SubjectID]               INT             NOT NULL,
    [SubjectCode]             NVARCHAR (50)   NULL,
    [CreditsECTS]             DECIMAL (18, 2) NULL,
    [Lectures]                INT             NOT NULL,
    [Practices]               INT             NOT NULL,
    [LaboratoryWork]          INT             NOT NULL,
    [IndependentStudentWork]  INT             NOT NULL,
    [ExamsOrder]              NVARCHAR (50)   NULL,
    [TestsOrder]              NVARCHAR (50)   NULL,
    [DirectionalProjectOrder] NVARCHAR (50)   NULL,
    [DirectionalWorkOrder]    NVARCHAR (50)   NULL,
    [FirstTerm]               DECIMAL (18, 2) NOT NULL,
    [SecondTerm]              DECIMAL (18, 2) NOT NULL,
    [ThirdTerm]               DECIMAL (18, 2) NOT NULL,
    [FourthTerm]              DECIMAL (18, 2) NOT NULL,
    [FifthTerm]               DECIMAL (18, 2) NOT NULL,
    [SixthTerm]               DECIMAL (18, 2) NOT NULL,
    [SeventhTerm]             DECIMAL (18, 2) NOT NULL,
    [EighthTerm]              DECIMAL (18, 2) NOT NULL
);



